class InitialSchema < ActiveRecord::Migration
  def self.up
    
    create_table "TL2MaterialsForTypeWithActivity", :id => false do |t|
      t.column "typeID", :integer
      t.column "activity", :integer
      t.column "requiredTypeID", :integer
      t.column "quantity", :integer
      t.column "damagePerJob", :float
    end
  
    create_table "dgmAttributeTypes", :id => false do |t|
      t.column "attributeID", :integer
      t.column "attributeName", :string, :limit => 100
      t.column "attributeCategory", :integer
      t.column "description", :text
      t.column "maxAttributeID", :integer
      t.column "attributeIdx", :integer
      t.column "graphicID", :integer
      t.column "chargeRechargeTimeID", :integer
      t.column "defaultValue", :integer
      t.column "published", :integer
      t.column "displayName", :string, :limit => 100
      t.column "unitID", :integer
      t.column "stackable", :integer
      t.column "highIsGood", :integer
    end
  
    create_table "dgmEffects", :id => false do |t|
      t.column "effectID", :integer
      t.column "effectName", :text
      t.column "effectCategory", :integer
      t.column "preExpression", :integer
      t.column "postExpression", :integer
      t.column "description", :text
      t.column "guid", :string, :limit => 60
      t.column "graphicID", :integer
      t.column "isOffensive", :integer
      t.column "isAssistance", :integer
      t.column "durationAttributeID", :integer
      t.column "trackingSpeedAttributeID", :integer
      t.column "dischargeAttributeID", :integer
      t.column "rangeAttributeID", :integer
      t.column "falloffAttributeID", :integer
      t.column "disallowAutoRepeat", :integer
      t.column "published", :integer
      t.column "displayName", :string, :limit => 100
      t.column "isWarpSafe", :integer
      t.column "rangeChance", :integer
      t.column "electronicChance", :integer
      t.column "propulsionChance", :integer
      t.column "distribution", :integer
      t.column "sfxName", :string, :limit => 20
      t.column "npcUsageChanceAttributeID", :integer
      t.column "npcActivationChanceAttributeID", :integer
      t.column "fittingUsageChanceAttributeID", :integer
    end
  
    create_table "dgmTypeAttributes", :id => false do |t|
      t.column "typeID", :integer
      t.column "attributeID", :integer
      t.column "valueInt", :integer
      t.column "valueFloat", :float
    end
  
    create_table "dgmTypeEffects", :id => false do |t|
      t.column "typeID", :integer
      t.column "effectID", :integer
      t.column "isDefault", :integer
    end
  
    create_table "invBlueprintTypes", :id => false do |t|
      t.column "blueprintTypeID", :integer
      t.column "parentBlueprintTypeID", :integer
      t.column "productTypeID", :integer
      t.column "productionTime", :integer
      t.column "techLevel", :integer
      t.column "researchProductivityTime", :integer
      t.column "researchMaterialTime", :integer
      t.column "researchCopyTime", :integer
      t.column "researchTechTime", :integer
      t.column "productivityModifier", :integer
      t.column "materialModifier", :integer
      t.column "wasteFactor", :integer
      t.column "chanceOfReverseEngineering", :float
      t.column "maxProductionLimit", :integer
    end
  
    create_table "invCategories", :id => false do |t|
      t.column "categoryID", :integer
      t.column "categoryName", :string, :limit => 100
      t.column "description", :text
      t.column "graphicID", :integer
    end
  
    create_table "invGroups", :id => false do |t|
      t.column "groupID", :integer
      t.column "categoryID", :integer
      t.column "groupName", :text
      t.column "description", :text
      t.column "graphicID", :integer
      t.column "useBasePrice", :integer
      t.column "allowManufacture", :integer
      t.column "allowRecycler", :integer
      t.column "anchored", :integer
      t.column "anchorable", :integer
      t.column "fittableNonSingleton", :integer
    end
  
    create_table "invMarketGroups", :id => false do |t|
      t.column "marketGroupID", :integer
      t.column "parentGroupID", :integer
      t.column "marketGroupName", :string, :limit => 100
      t.column "description", :text
      t.column "graphicID", :integer
      t.column "hasTypes", :integer
    end
  
    create_table "invMetaGroups", :id => false do |t|
      t.column "metaGroupID", :integer
      t.column "metaGroupName", :string, :limit => 100
      t.column "description", :text
      t.column "graphicID", :integer
    end
  
    create_table "invMetaTypes", :id => false do |t|
      t.column "typeID", :integer
      t.column "parentTypeID", :integer
      t.column "metaGroupID", :integer
    end
  
    create_table "invTypes", :id => false do |t|
      t.column "typeID", :integer
      t.column "groupID", :integer
      t.column "typeName", :string, :limit => 100
      t.column "description", :text
      t.column "graphicID", :integer
      t.column "radius", :float
      t.column "mass", :float
      t.column "volume", :float
      t.column "capacity", :float
      t.column "portionSize", :integer
      t.column "raceID", :integer
      t.column "basePrice", :float
      t.column "published", :integer
      t.column "marketGroupID", :integer
      t.column "chanceOfDuplicating", :float
    end
      
  end

  def self.down
  end
end
